package com.oceanread.cn.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.oceanread.cn.entity.Drillhole2;
import com.oceanread.cn.entity.Pipeline;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface Drillhole2Mapper extends BaseMapper<Drillhole2> {
    List<Drillhole2> getall();
    List<Drillhole2> query(@Param("key") String key, @Param("value") String value);
    List<Drillhole2> query2json(@Param("key") String key, @Param("value") String value,
                            @Param("key2") String key2, @Param("value2") String value2);

    List<Drillhole2> query1(@Param("start") int start, @Param("end") int end,
                            @Param("key") String key, @Param("value") String value);
    List<Drillhole2> query2(@Param("start") int start, @Param("end") int end,
                            @Param("key") String key, @Param("value") String value,
                            @Param("key2") String key2, @Param("value2") String value2);

    Integer getnumquery(@Param("key")String key, @Param("value")String value);
    Integer getnumquery2(@Param("key")String key, @Param("value")String value,
                         @Param("key2") String key2, @Param("value2") String value2);

    int insert(@Param("PrjCode") String PrjCode, @Param("PrjID") String PrjID,
               @Param("Order") Integer Order, @Param("Altitude") String Altitude,
               @Param("Start") String Start, @Param("Thickness") String Thickness,
               @Param("Material") String Material, @Param("Material0") String Material0);
    Integer update(@Param("SYSID") int SYSID, @Param("PrjCode") String PrjCode, @Param("PrjID") String PrjID,
                   @Param("Order") Integer Order, @Param("Altitude") String Altitude,
                   @Param("Start") String Start, @Param("Thickness") String Thickness,
                   @Param("Material") String Material, @Param("Material0") String Material0
    );
    Integer delete(@Param("SYSID") int SYSID);

}
